prepare('SELECT image FROM products WHERE product_code =:uid'); $stmt_select->execute(array(':uid'=>$_GET['delete_id'])); $imgRow=$stmt_select->fetch(PDO::FETCH_ASSOC); unlink("../img/".$imgRow['image']); // it will delete an actual record from db $stmt_delete = $DB_con->prepare('DELETE FROM products WHERE product_code =:uid'); $stmt_delete->bindParam(':uid',$_GET['delete_id']); $stmt_delete->execute(); header("Location: home.php"); } ?> Afia(Onlineservice)

  Add New Category

 Add New Items

prepare('SELECT product_code, product_name, image FROM products ORDER BY product_code DESC'); $stmt->execute(); if($stmt->rowCount() > 0) { while($row=$stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); ?>
  No Data Found ...